RC - Raw Composite ------------------ .. warning:: Submission of composite data has been deprecated from AQS. AQS will stop accepting composite data in the near future. The format is left in this document for interpreting composite data output from AQS. Composite transactions are used to submit concentrations derived from more than one intermittent atmostpheric sample. Format ^^^^^^ .. list-table:: RC - Raw Composite transaction format :widths: 1 5 15 4 3 1 :header-rows: 1 * - Seq. - Name - Description - Formatting Rules - Required - Key * - 1 - `Transaction Type `_ - Composite Raw Data transaction identifier. - Must = RC - Always - * - 2 - `Action Indicator `_ - Indicator for Insert, Update, or Delete action. - Must = I, U, or D - Always - * - 3 - `State Code / Tribal Indicator `_ - The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. - Must exist in STATES Reference Table or be 'TT' for Tribal Site - Always - * - 4 - `County Code / Tribal Code `_ - The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. - Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table - Always - * - 5 - `Site Number `_ - Four digit number to uniquely identify site in county and/or tribe. - Must exist in SITES table with {State Code, county Code} or Tribal Code - Always - * - 6 - `Parameter Code `_ - The AQS parameter code assigned to the monitor in AQS. - Must exist in PARAMETERS reference table. - Always - * - 7 - `POC `_ - Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. - Must exist in MONITOR table for non-Insert actions. - Always - * - 8 - `Reported Unit `_ - The unit of measure of the reported value. - Must exist in UNITS reference table. - Insert - * - 9 - `Method Code `_ - Identifies a particular method for collecting and analyzing samples. - Must exist in SAMPLING METHODOLOGIES reference table. - Insert - * - 10 - `Composite Data Year `_ - The calendar year for which the observation is reported. - YYYY. - Always - * - 11 - `Composite Period Code `_ - Indicates the time period within the year to which the observation applies. - Must exist in COMPOSITE TYPES reference table. - Always - * - 12 - `Number of Samples `_ - Indicates the number of samples that were combined to yield the composite sample value. - Integer - 10 digit. - Insert - * - 13 - `Composite Data Type `_ - Indicates the time period over which samples are composited or the frequency of submitting composite samples. - Must exist in COMPOSITE TYPES reference table. - No - * - 14 - `Reported Sample Value `_ - The value of a composite observation. - Decimal. - Insert - * - 15 - `Monitor Protocol ID `_ - The ID used to distinguish combinations of sample duration, unit, method, collection frequency, composite type, and alternate method detectable limit (MDL) for a monitor. - Must exist in MONITOR PROTOCOLS table for monitor. - No - * - 16 - `Qualifier Code - 1 `_ - Qualifications used to describe the composite raw data. - Must exist in QUALIFIERS reference table. - No - * - 17 - `Qualifier Code - 2 `_ - Qualifications used to describe the composite raw data. - Must exist in QUALIFIERS reference table. - No - * - 18 - `Qualifier Code - 3 `_ - Qualifications used to describe the composite raw data. - Must exist in QUALIFIERS reference table. - No - * - 19 - `Qualifier Code - 4 `_ - Qualifications used to describe the composite raw data. - Must exist in QUALIFIERS reference table. - No - * - 20 - `Qualifier Code - 5 `_ - Qualifications used to describe the composite raw data. - Must exist in QUALIFIERS reference table. - No - * - 21 - `Qualifier Code - 6 `_ - Qualifications used to describe the composite raw data. - Must exist in QUALIFIERS reference table. - No - * - 22 - `Qualifier Code - 7 `_ - Qualifications used to describe the composite raw data. - Must exist in QUALIFIERS reference table. - No - * - 23 - `Qualifier Code - 8 `_ - Qualifications used to describe the composite raw data. - Must exist in QUALIFIERS reference table. - No - * - 24 - `Qualifier Code - 9 `_ - Qualifications used to describe the composite raw data. - Must exist in QUALIFIERS reference table. - No - * - 25 - `Qualifier Code - 10 `_ - Qualifications used to describe the composite raw data. - Must exist in QUALIFIERS reference table. - No - * - 26 - `Alternate Method Detection Limit `_ - User supplied alternate to the federeal method detection limit (MDL). - Decimal. - No - * - 27 - `Measurement Uncertainty `_ - The value of method uncertainty associated with the sample. - Decimal. - No -